<?php
	/*Pagina de visualizacao e envio de arquivos para sala de reuniao*/

	session_start();

	include("/var/www/html/vivencias/conexaoBD.php");
	include("/var/www/html/vivencias/verificaRecursosAtivados.php");

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Experi&ecirc;ncias do Processo de Adoecimento</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="vivencias.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body onLoad="MM_preloadImages('imagens/stt_wiki2.jpg','imagens/stt_gloss2.jpg','imagens/stt_blogs2.jpg','imagens/sstt_chat2.jpg','imagens/sstt_visvers2.jpg','imagens/sstt_atividades2.jpg')">
<div align="center">
  <table width="1000" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="10%" align="left" valign="top"><strong><img src="imagens/logo.jpg" width="66" height="53"></strong></td>
                  <td width="90%"><img src="imagens/tit2.jpg" width="612" height="28"></td>
                </tr>
              </table></td>
          </tr>
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr align="left" valign="middle">
                  <td colspan="3" class="nomecurso"><?php echo $_SESSION['nomeCurso'];?></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td><strong><a href="index.php"><img src="imagens/sair.gif" width="33" height="19" border="0"></a></strong></td>
                </tr>
                <tr align="left" valign="middle">
                  <td width="25%">&nbsp;</td>
                  <td width="22%">&nbsp;</td>
                  <td width="52%">&nbsp;</td>
                  <td width="0%">&nbsp;</td>
                  <td width="0%">&nbsp;</td>
                  <td width="1%">&nbsp;</td>
                </tr>
              </table></td>
          </tr>
          <tr>
            <td><table width="96%" border="0" cellspacing="0" cellpadding="0">
                <tr align="left" valign="top">
		  <!--Gerenciamento só é visível ao professor. -->
		  <?php if(($_SESSION['idTipoUsuario']=='0')||($_SESSION['idTipoUsuario']=='1')||($_SESSION['idTipoUsuario']=="5")){?>
                  <td width="3%" background="imagens/bar_fnd_8.jpg" bgcolor="EBF4F9"><strong><a href="relatorios.htm"><img src="imagens/mn_8.jpg" width="23" height="161" border="0"></a></strong></td>
		  <?php } ?>
                  <td width="3%" background="imagens/bar_fnd_7.jpg"><strong><a href="info.php"><img src="imagens/mn_7.jpg" width="23" height="137" border="0"></a></strong></td>
                  <td width="3%" background="imagens/bar_fnd_6.jpg"><strong><a href="esppess.php"><img src="imagens/mn_6.jpg" width="23" height="156" border="0"></a></strong></td>
                  <td width="3%" background="imagens/bar_fnd_5.jpg"><strong><a href="comunicacao.php"><img src="imagens/mn_5.jpg" width="23" height="146" border="0"></a></strong></td>
                  <td width="3%" background="imagens/bar_fnd_4.jpg"><strong><a href="banco.php"><img src="imagens/mn_4.jpg" width="23" height="219" border="0"></a></strong></td>
                  <td width="3%" background="imagens/bar_fnd_3.jpg"><strong><a href="ferramentasTrabalho.php"><img src="imagens/mn_3.jpg" width="23" height="249" border="0"></a></strong></td>
                  <td width="71%" align="center" bgcolor="F5FEFF">
<table width="816" border="0" cellpadding="0" cellspacing="0">
                      <tr align="left" valign="top">
                        <td width="10" height="21"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                        <td width="129"><img src="imagens/stt_salaR2.jpg" width="129" height="21"></td>
			<?php if(($objetoN->wiki && $wiki)||($objetoN->wiki && $_SESSION['idTipoUsuario']=="0")||($objetoN->wiki && $_SESSION['idTipoUsuario']=="1")||($objetoN->wiki && $_SESSION['idTipoUsuario']=="5")){
			?>
                        <td width="10"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                        <td width="56"><a href="wiki.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('wiki1','','imagens/stt_wiki2.jpg',1)"><img src="imagens/stt_wiki1.jpg" name="wiki1" width="41" height="21" border="0" id="wiki1"></a></td>
			<?php } ?>
			<?php if(($objetoN->glossario && $glossario)||($objetoN->glossario && $_SESSION['idTipoUsuario']=="0")||($objetoN->glossario && $_SESSION['idTipoUsuario']=="1")||($objetoN->glossario && $_SESSION['idTipoUsuario']=="5")){
			?>
                        <td width="10"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                        <td width="91"><a href="glossario.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('glossario1','','imagens/stt_gloss2.jpg',1)"><img src="imagens/stt_gloss1.jpg" name="glossario1" width="78" height="21" border="0" id="glossario1"></a></td>
			<?php } ?>
			<?php if( ($objetoN->blog && $blog) || ($objetoN->blog && $_SESSION['idTipoUsuario']=="0") || ($objetoN->blog && $_SESSION['idTipoUsuario']=="1") || ($objetoN->blog && $_SESSION['idTipoUsuario']=="5") ){
			?>
                        <td width="10"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                        <td width="48"><a href="blogs.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('blogs1','','imagens/stt_blogs2.jpg',1)"><img src="imagens/stt_blogs1.jpg" name="blogs1" width="48" height="21" border="0" id="blogs1"></a></td>
			<?php } ?>
                        <td width="234"><img src="imagens/pix_branco.gif" width="230" height="5"></td>
                      </tr>
                      <tr align="center" valign="middle">
                        <td height="2" colspan="9"><img src="imagens/pix_cor2d.gif" width="810" height="2"></td>
                      </tr>
                      <tr align="left" valign="top">
                        <td colspan="9">
                          <table width="400" border="0" cellpadding="0" cellspacing="0">
                            <tr>
                              <td width="1%" height="20"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                              <td width="6%"><a href="salaRalunos.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image29','','imagens/sstt_atividades2.jpg',1)"><img src="imagens/sstt_atividades1.jpg" name="Image29" width="91" height="20" border="0"></a></td>
                              <td width="1%"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                              <td width="11%"><a href="javascript:void(0)" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('chat21','','imagens/sstt_chat2.jpg',1)" onClick="javascript:window.open('salaRForum.php','Janela','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=600,height=700');"><img src="imagens/sstt_chat1.jpg" name="chat21" width="55" height="20" border="0" id="chat21"></a></td>
                              <td width="1%"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                              <td width="23%"><a href="salaRVersoes.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('verversoes1','','imagens/sstt_visvers2.jpg',1)"><img src="imagens/sstt_visvers1.jpg" name="verversoes1" width="152" height="20" border="0" id="verversoes1"></a></td>
                              <td width="15%" colspan="8"><img src="imagens/pix_branco.gif" width="10" height="5"></td>
                              <td width="14%"><img src="imagens/sstt_arquiv2.jpg" width="76" height="20"></td>
                              <td width="28%">&nbsp;</td>
                            </tr>
                          </table>
                        </td>
                      </tr>
                    </table>
                    <br>
                    <table width="95%" border="0" cellpadding="5" cellspacing="1">
                      <tr>
                        <td align="center" valign="middle" bgcolor="d3f2f5"> <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                            <tr align="center" bgcolor="#38708F" class="texttab">
                              <td align="left" valign="top" bgcolor="9dd1d7">
                                <span class="ativo"><strong>Enviar arquivo</strong></span></td>
                            </tr>
			    <form enctype="multipart/form-data" name="formEnviaArquivo" action="insereArquivoSalaReuniao.php" method="post">
                            <tr align="center" bgcolor="#38708F" class="texttab">
                              <td align="left" valign="top" bgcolor="d3f2f5" class="texto2">Selecione
                                o arquivo
                                <input type="file" name="arquivo" value="Procurar">
                              </td>
                            </tr>
                            <tr align="center" bgcolor="#38708F" class="texttab">
                              <td align="left" valign="top" bgcolor="d3f2f5" class="texto2">ATEN&Ccedil;&Atilde;O:
                                N&Atilde;O utilize espa&ccedil;os no nome dos
                                arquivos!<br>
                                Arquivos com mais de 90 dias ou mais de 500Kb
                                ser&atilde;o apagados.</td>
                            </tr>
                            <tr align="center" bgcolor="#38708F" class="texttab">
                              <td align="left" valign="top" bgcolor="9dd1d7" class="texto2"><input type="submit" name="enviarArquivo" value="Enviar" <?php if(($_SESSION['idTipoUsuario'] == "0") || ($_SESSION['idTipoUsuario'] == "1")){ echo "disabled";}?>></td>
                            </tr>
			    </form>
                          </table></td>
                      </tr>
                      <tr>
                        <td bgcolor="F5FEFF">&nbsp;</td>
                      </tr>
                      <tr>
                        <td bgcolor="d3f2f5"> <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                            <tr align="center" valign="middle" bgcolor="9dd1d7" class="texttab">
                              <td align="left"> <span class="ativo"><strong>Exibir
                                arquivos </strong></span><span class="ativo"><strong>
                                </strong></span></td>
			      <form name="formOrdenaArquivos" method="post" action="salaRArquivos.php">
                              <td align="left"><span class="ativo"><strong>
                                <input type="radio" name="data" value="radiobutton">
                                </strong></span><span class="ativomenor"><strong>Por
                                data </strong></span><span class="ativo"><strong>
                                </strong></span></td>
                              <td align="left"><span class="ativomenor"><strong>
                                <input type="radio" name="aluno" value="radiobutton">
                                Por aluno</strong></span><span class="ativo"><strong>
                                </strong></span></td>
                              <td align="left"><span class="ativo"><strong>
                                <input type="submit" name="ordena" value="Ok">
			      </form>
                                </strong></span></td>
                            </tr>
                          </table></td>
                      </tr>
                      <tr>
                        <td bgcolor="F5FEFF">&nbsp;</td>
                      </tr>
                      <tr>
                        <td bgcolor="d3f2f5"><div align="center">
                            <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                              <tr align="center" bgcolor="9dd1d7" class="texttab">
                                <td colspan="6" align="left" valign="top"> <span class="ativo"><strong>Arquivos
                                  enviados</strong></span></td>
                              </tr>
                              <tr align="center" bgcolor="9dd1d7" class="texto2">
                                <td align="left" valign="top"><strong>Arquivo</strong></td>
                                <td align="left" valign="top"><strong>Formato</strong></td>
                                <td align="left" valign="top"><strong>Tamanho</strong></td>
                                <td align="left" valign="top"><strong>Enviado
                                  por </strong></td>
                                <td align="left" valign="top"><strong>Data/hora</strong></td>
				<td align="left" valign="top"><strong></strong></td>
                              </tr>
			      <?php

					/* Verifica a ordenacao dos arquivos escolhida pelo usuario */
					if($_POST['data']){
						$ordena = "salaReuniaoArquivos.dataHora DESC";
					}else{
						$ordena = "usuarios.nome"; //ordenacao padrao
					}

					if($_SESSION['idTipoUsuario'] == "2"){
						$queryG     = "SELECT grupo FROM usuariosCursos WHERE idUsuario=".$_SESSION['idUsuario']." AND idCurso=".$_SESSION['idCurso'];
						$resultadoG = mysql_query($queryG,$conexao);
						$objetoG    = mysql_fetch_object($resultadoG);

						$grupo      = $objetoG->grupo;
					}else{
						$grupo = $_SESSION['salaReuniao']['grupoVisualizadoPeloProfessor'];
					}

					$queryA     = "SELECT salaReuniaoArquivos.*,usuarios.nome FROM usuarios,salaReuniaoArquivos WHERE usuarios.idUsuario=salaReuniaoArquivos.idUsuario AND salaReuniaoArquivos.idCurso=".$_SESSION['idCurso']." AND salaReuniaoArquivos.grupo=".$grupo." ORDER BY ".$ordena;
					$resultadoA = mysql_query($queryA,$conexao);
					while($objetoA = mysql_fetch_object($resultadoA)){
						//Pega o nome do arquivo, sem o diretorio
						$nomeArquivo = explode("/",$objetoA->arquivo);
						$arquivo     = $nomeArquivo[4];
						//Pega o tamanho da string do nome do arquivo
						$tamanhoStrArquivo  = strlen($arquivo);
						$arquivoLimitado    = substr($arquivo,0,15);
						//Pega a extensao do arquivo
						$extensao = explode("/",$objetoA->extensaoArquivo);
						$extensaoNova = $extensao[1];
						//Formatando a data-hora
						$dataHora = explode(" ",$objetoA->dataHora);
						$data     = ereg_replace("([0-9]{2}([0-9]{2})?)[/.-]([01]?[0-9])[/.-]([0123]?[0-9])","\\4-\\3-\\1",$dataHora[0]);
						$hora     = $dataHora[1];

			      ?>
                              <tr align="center" bgcolor="#38708F" class="texto2">
                                <td align="left" valign="top" bgcolor="d3f2f5"><?php echo $arquivoLimitado;if($tamanhoStrArquivo > 15){echo "...";}?></td>
                                <td align="left" valign="top" bgcolor="d3f2f5" class="miudo"><?php echo $extensaoNova;?></td>
                                <td align="left" valign="top" bgcolor="d3f2f5" class="miudo"><?php echo $objetoA->tamanhoArquivo;?></td>
                                <td align="left" valign="top" bgcolor="d3f2f5"><?php echo $objetoA->nome;?></td>
                                <td align="left" valign="top" bgcolor="d3f2f5" class="miudo"><?php echo $data;?></br><?php echo $hora;?></td>
				<td align="left" valign="top" bgcolor="d3f2f5"><input type="button" name="baixar" value="Baixar" onClick="window.open('<?php echo $objetoA->arquivo;?>');"></td>
                              </tr>
			      <?php } ?>
                            </table>
                          </div></td>
                      </tr>
                    </table>
                    <p align="center">&nbsp;</p></td>
                  <td width="3%" align="right" background="imagens/bar_fnd_2.jpg"><strong><a href="conteudo.php"><img src="imagens/mn_2.jpg" width="23" height="113" border="0"></a></strong></td>
                  <td width="8%" align="right" background="imagens/bar_fnd_1.jpg" bgcolor="F1FEF9">
                    <p><strong><a href="principal.php"><img src="imagens/mn_1.jpg" width="23" height="103" border="0"></a></strong></p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p></td>
                </tr>
              </table></td>
          </tr>
        </table></td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</div>
</body>
</html>
